﻿CREATE TABLE [dbo].[DBInstrumentsStrategy] (
    [StrategiesID]  UNIQUEIDENTIFIER NOT NULL,
    [InstrumentsID] UNIQUEIDENTIFIER NOT NULL,
    PRIMARY KEY CLUSTERED ([StrategiesID] ASC, [InstrumentsID] ASC) WITH (ALLOW_PAGE_LOCKS = ON, ALLOW_ROW_LOCKS = ON, PAD_INDEX = OFF, IGNORE_DUP_KEY = OFF, STATISTICS_NORECOMPUTE = OFF),
    FOREIGN KEY ([StrategiesID]) REFERENCES [dbo].[DBStrategies] ([ID]) ON DELETE CASCADE ON UPDATE NO ACTION,
    FOREIGN KEY ([InstrumentsID]) REFERENCES [dbo].[DBInstruments] ([ID]) ON DELETE CASCADE ON UPDATE NO ACTION
);

